﻿Create PROCEDURE [dbo].[proc_Assets_BF_Getlist_Count]
	(
		@CompanyId int,
		@CategoryId int,
		@NameId int
	)
AS
	Select Count(Id) From Assets a
	Where (@CompanyId=0 Or a.CompanyId=@CompanyId) and (@CategoryId=0 Or a.CategoryId=@CategoryId) and (@NameId=0 Or a.NameId=@NameId) and IsApplyBf=1
	
	RETURN
